﻿--获取部门员工
create proc [dbo].[proc_Employee_GetDepartList]
(
	@departmentId nvarchar(2000)
)
as
	declare @sql nvarchar (4000)
	set @sql = 'select * from employee where '+'departmentid in ('+@departmentId+')'
	exec (@sql)

